Published queries
-
All articles not assigned to WikiProjects
3 months ago
-
Living people articles without WP Biography tag
5 months ago
-
Definitely dead people articles without WP Biography tag
5 months ago
-
Wikipedia articles without short description
5 months ago
-
Biographical articles without WP Biography tag
5 months ago
-
WikiProject to page category Xref, 50% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to pagecat counts, 10% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to talkcat counts, 10% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to page category Xref, 50% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to page category cross-reference, 10% scan, limited to 1M rows
1 year ago
-
WikiProject to page category cross-reference, 5% scan
1 year ago
-
Articles with talk pages that have been assigned to WikiProjects
1 year ago
-
Unicode/charset articles without talk pages
1 year ago
-
Wikidata entity values for enwiki pages
1 year ago
-
Unicode letters without talk pages
1 year ago
Starred Queries
This user has not starred any queries yet.
Draft Queries
-
Articles with talk pages but not assigned to WikiProjects
6 months ago
-
Untitled query #83006
7 months ago
-
TEST: WikiProject to page category Xref, 1% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to page category Xref, 10% scan, limit 2M rows, prefilter
1 year ago
-
WikiProject to page category Xref, 25% scan, limit 2M rows, prefilter
1 year ago
-
Unusual-prefix articles not assigned to WikiProjects
1 year ago
-
entities for article missing coordinates with coords on Wikidata
1 year ago
-
select (distinct cl_to, cl_from) from categorylinks
1 year ago
-
select count(*) from categorylinks
1 year ago
-
Short-title articles not assigned to WikiProjects
1 year ago
-
Quick stats from sampling page table
1 year ago
-
Articles without talk pages
1 year ago
-
Possible people articles without talk pages
1 year ago
-
Numeric-title articles not assigned to WikiProjects
1 year ago
-
Single-character title articles not assigned to WikiProjects
1 year ago
-
Year-title articles not assigned to WikiProjects
1 year ago
-
Sanity check re Biographical articles without WP Biography tag
1 year ago
-
test query for xref
1 year ago
-
wikidata
1 year ago
-
select count(distinct cl_from) from categorylinks
1 year ago
-
select count(distinct cl_to) from categorylinks
1 year ago
-
select cl_from, cl_to from categorylinks where cl_to like "%WikiProject%" limit 1000
1 year ago
-
Probable people articles with talk pages not assigned to WikiProjects
1 year ago
-
select count(*) from categorylinks where cl_to like "%WikiProject%"
1 year ago
-
Empty query
1 year ago
-
Peek one record from the page table
1 year ago
-
Minimalist article table test
1 year ago
-
Untitled query #71812
1 year ago
-
DESCRIBE page_props;
1 year ago
-
DESCRIBE templatelinks;
1 year ago
-
DESCRIBE categorylinks;
1 year ago
-
DESCRIBE page;
1 year ago
-
Article/talk join test
1 year ago
-
Article/talk join test, now expanded
1 year ago
-
SHOW INDEX FROM page;
1 year ago
-
Untitled query #71586
1 year ago
-
Untitled query #71749
1 year ago
-
p = np related articles
1 year ago
-
Untitled query #71629
1 year ago
-
Untitled query #71531
1 year ago
-
Untitled query #69567
2 years ago
-
Untitled query #69090
2 years ago
-
Untitled query #65665
2 years ago
-
Untitled query #48269
4 years ago